MacWorld 1998 January/Macworld (1998-01).dmg/FileMaker Pro 4/Full FM4 Templates/Business/Timecards

FileMaker Pro Database | 1997-09-14 | 113KB | 648 lines

HBAM2016AUG95
Pro 3.0
HBAM3016AUG95
HP DeskJet 540 Printer
$Q@g*
7/31/97
BEGIN WEEK
COMMENTS
CURRENT WEEK
DAY FLAG 1
DAY FLAG 2
DAY FLAG 3
DAY FLAG 4
DAY FLAG 5
DAY FLAG 6
DAY FLAG 7
DAY NAME 1
DAY NAME 2
DAY NAME 3
DAY NAME 4
DAY NAME 5
DAY NAME 6
DAY NAME 7
DAY TYPE
EMPLOYEE ID
END TIME
END WEEK
FIRST NAME
HOURS LEFT
#    LAST NAME
LUNCH HOURS
MARK CHARACTER
START TIME
TODAY'S DATE
TODAY'S DAY NAME
TOTAL HOURS
WEEK START DAY
WORK HOURS
WORK WEEK HOURS
Begin WeekB
End WeekB
Today's DateB
Start TimeB
Lunch HoursB
End TimeB
Work HoursB
 ) +
 ) / 60 -
Day TypeB
Day Name 1B
Day Name 2B
 + 1)
Day Name 3B
 + 2)
Day Name 4B
 + 3)
Day Name 5B
 + 4)
Day Name 6B
 + 5)
Day Name 7B
 + 6)
Total HoursB
Hours LeftB
CommentsB
Current WeekB
Week Start DayB
) = "Monday"
) = "Tuesday"
) = "Wednesday"
) = "Thursday"
) = "Friday"
) = "Saturday"
) = "Sunday"
 - 6)
Monday
Tuesday
    Wednesday
Thursday
Friday
Saturday
Sunday
Day Flag 1B
Day Flag 2B
Day Flag 3B
Day Flag 4B
Day Flag 5B
Day Flag 6B
Day Flag 7B
First NameB
Employee IDB
Today's Day NameB
Mark CharacterB
InfoB
Work Week HoursB
%A    Last NameB
7/31/97
Description
This database keeps track of employee hours, and is based on the standard employee timecard.
How to use this solution
Your employees can enter their hours directly into the database, or you can print blank Timecard reports for them to fill out and return.
The database calculates the hours worked based on the start time, lunch duration, and end time.
How to customize this solution
You can add fields to calculate the employee's pay, based on the hours they worked and their paBfy rate.
You can also track vacation and sick time, by adding a summary field for each time category.
A    Form View
@#A    List View
Information
Report Menu
Timecard Form
A    Form ViewB
A    List ViewB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Begin Week
End Week
Start Time
Lunch Hours
End Time
Work Hours
Day Type
Total This Week
Hours Left
Comments
Week #
First Name
Emp. ID
Close
View As
View As
Reports
Record
Delete
Record
Record
Your Own
Button
Your Own
Button
K Enter data for Employee Timecard
Standard
Week (hrs)
Today
Y    Timecards
[    Last Name
InformationB
Yesfter
Noarter
Yesfter
Noarter
Close
View As
View As
Reports
Record
Delete
Record
Record
Your Own
Button
Your Own
Button
O6Click to see more information for an Employee Timecard
Emp. ID
First Name
Week #
Begin Week
Total Hrs.
d    Last Name
InfoF
CloseG
View As
FormH
View As
ListI
ReportsJ
Your Own
ButtonK
Info for this Solution
A0Information about the Employee Timecard solution
Report MenuB
InfoB
CloseC
View As
FormD
View As
ListE
ReportsF
Your Own
Button
Timecard FormB
InfoB
CloseC
View As
FormD
View As
ListE
ReportsF
Your Own
ButtonG>Click on any of these buttons to preview the respective reportH
Timecard ReportI
Your Own ReportJ
Your Own
ReportK
Your Own
ReportL
Select a report
n any of these buttons to preview the respective reportH
Timecard ReportI
Your Own ReportJ
Your Own
ReportK
Your Own
ReportL
Select a report
7/28/97B
8/3/97I
MondayJ
TuesdayL    WednesdayM
ThursdayN
FridayO
SaturdayP
SundayT
InfoK
CloseL
View As
InfoK
CloseL
View As
View As
ListN
ReportsO
Your Own
ButtonU
Start TimeW
Lunch HoursY
End Time[
Work Hours]
Day Typef
Commentsn
Company Name and Logoo
Timecard Formq
Begin Weeks
End Weekw
Week #{
First Name}
Employee #
I5Please return completed form to personnel department.
Rev. 09/29/95
Printed:  //
Employee Signature
Manager Signature
Total Hours
)=400
Cancel
You did not enter any find criteria; all records will be displayed.C+
) = 0
Cancel
No records match this request.E)
Sort by Employee Name
Sort by Current Week
Timecard Report
wwwwww
    ffffff
UUUUUU
DDDDDD
333333
Sort by Current Week
Sort by Employee Name
Timecard Report
Open Script
Open Script
wwwwww
    ffffff
UUUUUU
DDDDDD
333333
wwffeffg@
veUEDDCC
vUTDD44
vUDDC32
#""#
weUDD3
veTDC2233#3#2
wUDDC3##"
vUTD3#22
vUDDC
fUD42233##3#"!
vTDCC##"
eUDC3223##
fTD4C3##23#""
uTDC3323#2""!
22"2"
##2"!
fTDD33#22""
vUDC32"2""
WUTC22
eTD3#""
GDC32"!!
eD3#"!
T32""
"%UR
UD33D
#4EWp
"4EVx
#3EVg
"4DUg
#3EVg
"#4DVg
24EVgy
"34EVw
##4Efw
""3DUgw
""33DUfw
""34DVgx
""#34EVgx
"#33DEfw
"    234DUfw
2""2334DEVgx
3    4DEUfwx
3    DDUVgw
D    EUUfwx
UDDEUUfgw
U    Vfgwx
eUVfgww
wwwwww
    ffffff
UUUUUU
DDDDDD
333333
""""""
wwxwwxw
ggvgvv
gvwxgwghg
vhgvvww
fvfgfwffv
eVefefe
VvffVefVVefUe\
ffFdeefeefddfDeVd
fEdfFdffk
EUeFFEUFEUFFUeTeVFeUUdVEEk
UTdUTeETeETeEUFTUTUFTUUTeK
TEETEETUETUETUDUDEETUDTUE[
4CDD4E4ET
DDCD4DD4CDDC
C3C3C34C4C3CC43C
"#""3"129
#11#22122"3!
(LIST
LISTA!Regular
Holiday
Vacation
Sick Day
VDEFA(
dayTypes
wwwwww
    ffffff
UUUUUU
DDDDDD
333333
""""""
#11#22122"3!
"#""3"129
AD@D@
AD@D@
C3C3C34C4C3CC43C
DDCD4DD4CDDC
4CDD4E4ET
TEETEETUETUETUDUDEETUDTUE[
UTdUTeETeETeEUFTUTUFTUUTeK
EUeFFEUFEUFFUeTeVFeUUdVEEk
ffFdeefeefddfDeVdfEdfFdffk
eVefefe
VvffVefVVefUe\
fvfgfwffv
ggvgvv
gvwxgwghg
vhgvvww
wwxwwxw
B"#B@
B"#B"$
4"2$B"#B"#C
2$""#B"#C0
4"2#B"#C0
2$B"#C0
4""#C0
44444
CCCCC 44444 CCCCC
$42"
 JJJJ
!BBBB
"99BB
#9999
$9911
%1111
&))))
'!!!!
 *00**-
*00-00
00*0)
00*&0#
## !0*!%00+#!*0##-0'"0*#%00.!
UUUUU
bRBBP0
@@BA@
UUUUUU
wwwwww
(*)(%,3&
)%+@6)
",30,)%
 #*>A6332+$"!
25,878
#&$690*"
!)0,++)(
 "%/66435/'#
+3;4*=
!#,@9,)+,(""(-/,,*
!$&(265389,#!$$
'275?
" $$*23/$
$),-..)''
!$&)(-5439@1!!&*-3/)!!%6B)
)220(!$*.,,.'
!$&*,*023:?B+*.,/3254.'
"++,3/(.584.,"
!#&+/-./3:9@G@60/16883)!
$++//'(9CD>4.$$
$%)*-//2693,.075-&)3792,$
")-1347<>@G71(!
**)&'*.0350+%(=A2'%)579<94(
+/11!
!%'),342)1?=0)"
.1,$',-01)*).AG6-/048:<
/2583$%+66/%
 %)++*),+&%06,%$#
!/40')-/31$$,@HFC<6887:==@B7%!
6A235,%
+,/13.%#"(16+
!#$(04-$&+,+$
%2>D6,59:989889=0
,.22<=33*
.22671#
!!&/42&
*1$&+,/3779733,
 $$PQ
/004B6*
!$$ $))'/3)
%&$&.7;4
)2$)*3-)466/%$
!),02+'
%$5)%*+%$!
(+'0:==4
$+,,1643"%)"
!)/1)*+
+7=-%%&$!
!3)3=.
%&*/3113
 !$$PQ
',4-%)/)
,6/%$$"
+(!<-
%),0354-
.13-&,-*
14'$$!
%))&%$!
'3*$$"
!&$%3
&%"%&
9836'
)&#%%!
$*)++"
.-/:%
!"&)()15,
)" /.-+)!
//6B&
 #'*,.42$
$/,-*%
IF1A1
"%.2/-*#!
$/.,*($!#$"%PQ
#57-*'$#"$&'
..//.-,)'(.212PQ
",,)&%'.;<6/+',,)%!
'//,+//*)+.4:=>PQ
$(&(),5?@:2/,,''*$
-!,,%.0%)./7
#43((+9CA=3+,)+"
&*)2!$96;;48@??PQ
)/01%$
#3/').:@<3)$&)!
/)4$%)8=A@?><@PQ
!.0/.+//./1//*
*.').3784/%
,,#%()25:<99=PQ
%10//
0 /+134,.25653."
)++-!
# %0,*,384'%PQ
42//11/&(/563135650(
(./36$
!"23.,27-
6:=<)&931-13-!$.69433563+
,/258 #$,96-37)$!PQ
38;?B>;63/.22.-068934673(
,638<6$
*),/6."')==138*$)PQ
35:=@B>953-/1.-368<:8995&
%668:9(
)$'*.:&$*==8/,
-19=@CA>:83+2.,0157:
!""/88$
!)*# 6/0%&' !$*38,.<;60"
+07=@CD=6>@.*)&(*-03;@@<-
6.3/%
#/23989=2,*%
/039>B@ "9E7,)+/3667:?CE/!"
$$%199207/
9K8@)
3933"
!0042381%$(.-)56PQ
556:=@@
5C958=BGGA96;='"+-
!!%.94.6BDCFM='(204967&
//2346%
$59232$PQ
:9<@?@C% 6D;;CJLONG952
(9304=FCDDE>%
$,585'
!.//11'$/;81$
9:CE><D3,5G@@HF>IF94)
$#%+*159C=:>FG)
*31*#
$/51#
89C=.!:9=C<9AFGCA7&(
/%3%!'+5A<6=C>$
-672.3<<961.%!
,,%=<9/69/02.
"773//33/,+)
/1$'9<
069850(*)'%
%/+$
!&##34
%0<PQ
%"$:C9.*$
!+6@PQ
"$$6CD>>5
!##()
".;CPQ
 %'0>GFA:378+&&%$$,&
,:CPQ
$(,027CGG@6681//,)%$/
'7CPQ
!%*/1,/44CC;6547@=2*!%.$
%;CPQ
'$)=3
 #%)*())3DLHB
?MB9/% !
"'6?6$
*;=PQ
$%&,9D6
!$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ
!)/38;@(
"$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ
+/0,$%&%%,26:5)
"$%&(/7;<=BGIJIGMG=953'%(1<<63/!
$*.8PQ
876=@?<3),3:8$
!&((),3=;::=EHIC:<F3)'""#&+/,',
#&(0PQ
FC8:CF@7/08<(
"'()*,
169?:6=C=2..3'"
"%&)PQ
HD99=A@9534/
!26(%5,
! !),''*-16<@=430/,+/)!
??979>@@:-!
!$+%-*),/37<@:2/-*)+*"
4?=95;@@9&
*#%.,/136884/,)'),,%)+(%$$
/>C:13?@9)$
!!89+
!)$%*-/13321/,*3*)-/0/+&$$!
 6A:0,8B=1+)/68.%/(,9=2%
")$"%)-02331/31)/().241+%##!
*79/)/:<651/33)2<8.6=9.
!$%,56643/75,'&).340+&#!$$%#!
.5.)/46682%#$$-973:=<7)
!$'+4:964063+(
,33/+(&'),*)'#
"%%.2379:1&"%(&.36@?@D5
!$%')/8:86>=2)&!!-231
34772+*
 &46339C@4+,3/)/:<D/8J='
"%'))+336@3(/)%#%,34569<=?CE5,)!
 #'21.7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,&
#,0258<?ADGE2 "'(#
"%),,/6983$
&4<9+4DD>?J>/*-6;<6,,/25.))3,'
",.0369;=AGE.
!%%(,.040'
2A?EA4*+/683*.493/($!/-,
0246689:AC7%
$%##(.23&
:96,#"%)*(%(364,M4%"!!"560&)/<9;989;>3$
"03., PQ
UUUUUU
wwwwww
Sunday
Monday
Tuesday
    Wednesday
Thursday
Friday
Saturday
January
February
March
April
August
    September
October
November
December
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
Arial
MS Sans Serif
    Helvetica
Times
Times New Roman
Geneva
wwwwww
    ffffff
UUUUUU
DDDDDD
333333
Pro 3.0F!
Pro 3.0 - 4.0M%